# check if the county names in well data and emp data are the same

BEGIN {
  FS = ","
  OFS = ","
  while ((getline line < "/home/huizi/HOLA/research/green-jobs/data/raw/tx_RRC_county_emp.txt") > 0) {
    split (line, x)
    county = x[2]
    year = x[3]
    emp[county,year] = x[4]
  }
}

{
  if ($1 SUBSEP $2 in emp)
   next
  else
    print $0
}
